EMT Practice Test

1. Question Content...

---

Question1: An administrator is tasked with auditing NDB SLAs. What data will the administrator be reviewing?

Question2: An administrator needs to maintain five days of time-travel capability to any second, plus an additional seven days of discrete recovery at a daily interval.
How should the administrator define the Frequency and retention on the SLA?

Question3: How does NDB send notifications when alerts are generated?

Question4: A request is received to refresh a database clone from a new manual snapshot. When the administrator attempts to create the new snapshot from the Time Machine, it is in a Frozen state.
What causes a Time Machine to enter the Frozen state and what are the administrator's options to complete the request?

Question5: Refer to the exhibit.

An administrator is receiving critical NDB email alerts regarding storage for the DBA database, which is a member of a database group.
How would the administrator remediate the issue within NDB?

Question6: An administrator needs to roll back an Oracle patch on a database server VM using NDB. What is required for this action to be successful?

Question7: A database administrator wants to define initialization variables for different types of database engines and workloads, like OLTP and DW.
What type of profile would be used?

Question8: An administrator needs to take multiple snapshots per day and retain them for one week. How should the administrator define and schedule the SLA?

Question9: An administrator needs to deploy a cumulative update (CU) for SQL Server.
What steps would the administrator take to prepare this deployment with NDB?

Question10: An administrator enables NDB Multi-Cluster on Cluster A. Cluster B is then registered with NDB.
What are the different NDB Service VMs present in each Nutanix cluster?

Question11: An administrator needs to patch a PostgreSQL database server VM from version 13.4 to 13.8.
What is the first step within the NDB patching workflow to accomplish this task?

Question12: An administrator is tasked with providing a Jr DBA with access to NBD with limited capabilities.
This user should only be able to:
* Provision Databases
* Provision Database Servers
* Create Ones
* Refresh Clones
* Patch Database Servers
How can the administrator complete this task?

Question13: What is the minimum frequency in minutes configurable for NDB Log Catch-up operation?

Question14: Within the NDB GUI, an administrator needs to set the shortest schedule interval possible for a database log catch up.
Which value, in minutes, will satisfy this requirement?

Question15: What is purpose of the NDB Database Agent service?

Question16: Refer to the exhibit.

An administrator attempts to provision their first clustered database environment with NDB. The operation fails with the Operation Error shown in the exhibit.
Which database engine was being deployed during this operation?

Question17: What does a Time Machine frozen status indicate?

Question18: An administrator needs to create a custom PostgreSQL HA software profile.
Which software component manages the state of the cluster and handles failover?

Question19: Which NDB feature collects logs and snapshots from databases?

Question20: Which two options can NDB leverage to refresh a database clone? (Choose two.)

Question21: A customer has NDB configured to create snapshots of their production databases every 4 hours.
A developer requires a copy of the current production data at 7:00am of each day.
What is the most efficient way to meet this requirement?

Question22: What happens to the primary member in a MongoDB Server Cluster during the NDB patching process?

Question23: What step should be taken to make the profile available to all users:

Question24: How can HA drivers for a Database VM be upgraded?

Question25: When provisioning an PostgreSQL HA Instance, what are the minimum and maximum number of DB server VMs that can be deployed in a cluster?

Question26: When preparing to provision multiple database server VMs, an administrator is tasked with configuring this set of VMs with the same number of cores per vCPU.
What is the easiest way for the administrator to accomplish this task?

Question27: An administrator has configured NDB HA across multiple Nutanix clusters.
Which failure scenario will require manual interaction for the recovery?

Question28: What is required to create an NDB Software Profile Version for PostgreSQL?

Question29: An administrator is trying to register a database server VM with NDB.
Which file types will prevent the registration from being successful if located in the C:\ drive?

Question30: An administrator created a database clone that is scheduled for removal on the last day of the month.
A request has been received to keep the clone for an additional 14 days.
After selecting the desired clone, how should the administrator satisfy this task?

Question31: What is the purpose of Data Access Management policies in NDBMulti-Cluster?

Question32: Within NDB, an administrator needs to register a PostgreSQL database server VM with a database.
Where should the database data and log files be located in order to successfully complete this task?

Question33: An administrator needs to register a SQL Server Single Node Database Server VM with NDB.
Which condition must exist prior to the administrator completing this task?

Question34: An administrator needs to make new VLANs available when provisioning a Oracle cluster database, which have been added to NDB via the Administration menu.
What needs to be done to expose the new VLANs for provisioning?

Question35: An administrator is interested in using profiles to simplify the database provisioning process. The profile needs to include information related to the SQL service startup account, and the NDB worker service account.
Which profile would help the administrator accomplish this task?

Question36: Which statement best describes what happens when a 3rd-party backup tool is chosen to manage log backups for Microsoft SQL in NDB?

Question37: An administrator has been tasked with restoring an Oracle database that has recently failed. The administrator must restore the database to the prior day's state.
Which two restore options could be used? (Choose two.)